{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["tala sod ojrat","طلای خام","فرمت به کارفرما ","توضیحات "],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"tala sod ojrat","index":0,"n_rows":200,"n_cols":20,"rows_kept":200,"cut":false,"hidden":false,"merged":[]}
["تاریخ ","مبلغ واحد","اجرت ","سود ","پرداخت شده ","شماره فاکتور ","کد طرف حساب ","کد کالا ","ارزش افزوده ","عیار","تعداد ","مبلغ تخفیف","اجرت ساخت","سود فروشنده","نوع","الگو","موضوع","روش تسویه","اختلاف ","تعداد با اعشار"]
["1404-06-24",87000000,10,20,300000000,100,{"$f":"IF(E2>0,100,\"\")","v":100},100,0,18,{"$f":"IF(IF((ROUNDDOWN(T2,4)*10000)-ROUNDDOWN(T2,3)*10000>5,ROUNDUP(T2,3)+0.001,ROUNDUP(T2,3))=0,\"\",IF((ROUNDDOWN(T2,4)*10000)-ROUNDDOWN(T2,3)*10000>5,ROUNDUP(T2,3)+0.001,ROUNDUP(T2,3)))","v":2.613},{"$f":"IFERROR(IF(E2>0,IF(ROUNDDOWN(K2*B2,0)+ROUNDDOWN(ROUNDDOWN(K2*B2,0)*C2%,0)+ROUNDDOWN((ROUNDDOWN(K2*B2,0)+ROUNDDOWN(ROUNDDOWN(K2*B2,0)*C2%,0))*D2%,0)+ROUNDDOWN((M2+N2)*I2%,0)-E2>(K2*B2)*1%,0,IF(ROUNDDOWN(K2*B2,0)+ROUNDDOWN(ROUNDDOWN(K2*B2,0)*C2%,0)+ROUNDDOWN((ROUNDDOWN(K2*B2,0)+ROUNDDOWN(ROUNDDOWN(K2*B2,0)*C2%,0))*D2%,0)+ROUNDDOWN((M2+N2)*I2%,0)-E2<0,0,ROUNDDOWN(K2*B2,0)+ROUNDDOWN(ROUNDDOWN(K2*B2,0)*C2%,0)+ROUNDDOWN((ROUNDDOWN(K2*B2,0)+ROUNDDOWN(ROUNDDOWN(K2*B2,0)*C2%,0))*D2%,0)+ROUNDDOWN((M2+N2)*I2%,0)-E2)),\"\"),0)","v":76920},{"$f":"IFERROR(IF(E2>0,ROUNDDOWN(ROUNDDOWN(K2*B2,0)*C2%,0),\"\"),\"\")","v":22733100},{"$f":"IFERROR(IF(E2>0,ROUNDDOWN((ROUNDDOWN(K2*B2,0)+ROUNDDOWN(ROUNDDOWN(K2*B2,0)*C2%,0))*D2%,0),\"\"),\"\")","v":50012820},{"$f":"IF(F2<>\"\",2,\"\")","v":2},{"$f":"IF(F2<>\"\",3,\"\")","v":3},{"$f":"IF(F2<>\"\",1,\"\")","v":1},{"$f":"IF(F2<>\"\",1,\"\")","v":1},{"$f":"IFERROR(IF(E2>0,ROUNDDOWN(K2*B2,0)+ROUNDDOWN(ROUNDDOWN(K2*B2,0)*C2%,0)+ROUNDDOWN((ROUNDDOWN(K2*B2,0)+ROUNDDOWN(ROUNDDOWN(K2*B2,0)*C2%,0))*D2%,0)+ROUNDDOWN((M2+N2)*I2%,0)-E2-L2,\"\"),0)","v":0},2.6122268224067193]
[null,52850000,18,7,10000000,{"$f":"IF(E3>0,F2+1,\"\")","v":101},{"$f":"IF(E3>0,G2,\"\")","v":100},{"$f":"IF(E3>0,H2,\"\")","v":100},10,{"$f":"IF(E3>0,J2,\"\")","v":18},0.14699999999999999,{"$f":"IF(E3>0,IF(ROUNDDOWN(K3*B3,0)+ROUNDDOWN(ROUNDDOWN(K3*B3,0)*C3%,0)+ROUNDDOWN((ROUNDDOWN(K3*B3,0)+ROUNDDOWN(ROUNDDOWN(K3*B3,0)*C3%,0))*D3%,0)+ROUNDDOWN((M3+N3)*I3%,0)-E3>(K3*B3)*1%,0,IF(ROUNDDOWN(K3*B3,0)+ROUNDDOWN(ROUNDDOWN(K3*B3,0)*C3%,0)+ROUNDDOWN((ROUNDDOWN(K3*B3,0)+ROUNDDOWN(ROUNDDOWN(K3*B3,0)*C3%,0))*D3%,0)+ROUNDDOWN((M3+N3)*I3%,0)-E3<0,0,ROUNDDOWN(K3*B3,0)+ROUNDDOWN(ROUNDDOWN(K3*B3,0)*C3%,0)+ROUNDDOWN((ROUNDDOWN(K3*B3,0)+ROUNDDOWN(ROUNDDOWN(K3*B3,0)*C3%,0))*D3%,0)+ROUNDDOWN((M3+N3)*I3%,0)-E3)),\"\")","v":13088},{"$f":"IF(E3>0,ROUNDDOWN(ROUNDDOWN(K3*B3,0)*C3%,0),\"\")","v":1398411},{"$f":"IF(E3>0,ROUNDDOWN((ROUNDDOWN(K3*B3,0)+ROUNDDOWN(ROUNDDOWN(K3*B3,0)*C3%,0))*D3%,0),\"\")","v":641715},{"$f":"IF(F3<>\"\",2,\"\")","v":2},{"$f":"IF(F3<>\"\",3,\"\")","v":3},{"$f":"IF(F3<>\"\",1,\"\")","v":1},{"$f":"IF(F3<>\"\",1,\"\")","v":1},0,0.14571597989639337]
[null,52370000,12,7,100000000,102,{"$f":"IF(E4>0,G3,\"\")","v":100},{"$f":"IF(E4>0,H3,\"\")","v":100},10,18,1.5679999999999998,37189,9853939,6437906,2,3,1,1,0,1.5674170722750103]
[null,53550000,18,7,2000000000,103,100,100,10,18,28.979000000000003,85749,279328581,128180782,2,3,1,1,0,28.97775760211719]
[null,80000000,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","",{"$f":"IF(F19<>\"\",2,\"\")","v":""},{"$f":"IF(F19<>\"\",3,\"\")","v":""},{"$f":"IF(F19<>\"\",1,\"\")","v":""},{"$f":"IF(F19<>\"\",1,\"\")","v":""},""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"",{"$f":"IF(IF((ROUNDDOWN(T34,4)*10000)-ROUNDDOWN(T34,3)*10000>5,ROUNDUP(T34,3)+0.001,ROUNDUP(T34,3))=0,\"\",IF((ROUNDDOWN(T34,4)*10000)-ROUNDDOWN(T34,3)*10000>5,ROUNDUP(T34,3)+0.001,ROUNDUP(T34,3)))","v":""},"","","","","","","",{"$f":"IFERROR(IF(E34>0,ROUNDDOWN(K34*B34,0)+ROUNDDOWN(ROUNDDOWN(K34*B34,0)*C34%,0)+ROUNDDOWN((ROUNDDOWN(K34*B34,0)+ROUNDDOWN(ROUNDDOWN(K34*B34,0)*C34%,0))*D34%,0)+ROUNDDOWN((M34+N34)*I34%,0)-E34-L34,\"\"),0)","v":""}]
[null,null,null,null,null,{"$f":"IF(E35>0,F34+1,\"\")","v":""},"","",null,{"$f":"IF(E35>0,J34,\"\")","v":""},"",{"$f":"IF(E35>0,IF(ROUNDDOWN(K35*B35,0)+ROUNDDOWN(ROUNDDOWN(K35*B35,0)*C35%,0)+ROUNDDOWN((ROUNDDOWN(K35*B35,0)+ROUNDDOWN(ROUNDDOWN(K35*B35,0)*C35%,0))*D35%,0)+ROUNDDOWN((M35+N35)*I35%,0)-E35>(K35*B35)*1%,0,IF(ROUNDDOWN(K35*B35,0)+ROUNDDOWN(ROUNDDOWN(K35*B35,0)*C35%,0)+ROUNDDOWN((ROUNDDOWN(K35*B35,0)+ROUNDDOWN(ROUNDDOWN(K35*B35,0)*C35%,0))*D35%,0)+ROUNDDOWN((M35+N35)*I35%,0)-E35<0,0,ROUNDDOWN(K35*B35,0)+ROUNDDOWN(ROUNDDOWN(K35*B35,0)*C35%,0)+ROUNDDOWN((ROUNDDOWN(K35*B35,0)+ROUNDDOWN(ROUNDDOWN(K35*B35,0)*C35%,0))*D35%,0)+ROUNDDOWN((M35+N35)*I35%,0)-E35)),\"\")","v":""},{"$f":"IF(E35>0,ROUNDDOWN(ROUNDDOWN(K35*B35,0)*C35%,0),\"\")","v":""},{"$f":"IF(E35>0,ROUNDDOWN((ROUNDDOWN(K35*B35,0)+ROUNDDOWN(ROUNDDOWN(K35*B35,0)*C35%,0))*D35%,0),\"\")","v":""},"","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","",{"$f":"IF(F51<>\"\",2,\"\")","v":""},{"$f":"IF(F51<>\"\",3,\"\")","v":""},{"$f":"IF(F51<>\"\",1,\"\")","v":""},{"$f":"IF(F51<>\"\",1,\"\")","v":""},""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"",{"$f":"IF(IF((ROUNDDOWN(T66,4)*10000)-ROUNDDOWN(T66,3)*10000>5,ROUNDUP(T66,3)+0.001,ROUNDUP(T66,3))=0,\"\",IF((ROUNDDOWN(T66,4)*10000)-ROUNDDOWN(T66,3)*10000>5,ROUNDUP(T66,3)+0.001,ROUNDUP(T66,3)))","v":""},"","","","","","","",{"$f":"IFERROR(IF(E66>0,ROUNDDOWN(K66*B66,0)+ROUNDDOWN(ROUNDDOWN(K66*B66,0)*C66%,0)+ROUNDDOWN((ROUNDDOWN(K66*B66,0)+ROUNDDOWN(ROUNDDOWN(K66*B66,0)*C66%,0))*D66%,0)+ROUNDDOWN((M66+N66)*I66%,0)-E66-L66,\"\"),0)","v":""}]
[null,null,null,null,null,{"$f":"IF(E67>0,F66+1,\"\")","v":""},"","",null,{"$f":"IF(E67>0,J66,\"\")","v":""},"",{"$f":"IF(E67>0,IF(ROUNDDOWN(K67*B67,0)+ROUNDDOWN(ROUNDDOWN(K67*B67,0)*C67%,0)+ROUNDDOWN((ROUNDDOWN(K67*B67,0)+ROUNDDOWN(ROUNDDOWN(K67*B67,0)*C67%,0))*D67%,0)+ROUNDDOWN((M67+N67)*I67%,0)-E67>(K67*B67)*1%,0,IF(ROUNDDOWN(K67*B67,0)+ROUNDDOWN(ROUNDDOWN(K67*B67,0)*C67%,0)+ROUNDDOWN((ROUNDDOWN(K67*B67,0)+ROUNDDOWN(ROUNDDOWN(K67*B67,0)*C67%,0))*D67%,0)+ROUNDDOWN((M67+N67)*I67%,0)-E67<0,0,ROUNDDOWN(K67*B67,0)+ROUNDDOWN(ROUNDDOWN(K67*B67,0)*C67%,0)+ROUNDDOWN((ROUNDDOWN(K67*B67,0)+ROUNDDOWN(ROUNDDOWN(K67*B67,0)*C67%,0))*D67%,0)+ROUNDDOWN((M67+N67)*I67%,0)-E67)),\"\")","v":""},{"$f":"IF(E67>0,ROUNDDOWN(ROUNDDOWN(K67*B67,0)*C67%,0),\"\")","v":""},{"$f":"IF(E67>0,ROUNDDOWN((ROUNDDOWN(K67*B67,0)+ROUNDDOWN(ROUNDDOWN(K67*B67,0)*C67%,0))*D67%,0),\"\")","v":""},"","","","",""]
[null,null,null,null,null,"",{"$f":"IF(E68>0,G67,\"\")","v":""},{"$f":"IF(E68>0,H67,\"\")","v":""},null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","",{"$f":"IF(F83<>\"\",2,\"\")","v":""},{"$f":"IF(F83<>\"\",3,\"\")","v":""},{"$f":"IF(F83<>\"\",1,\"\")","v":""},{"$f":"IF(F83<>\"\",1,\"\")","v":""},""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"",{"$f":"IF(IF((ROUNDDOWN(T98,4)*10000)-ROUNDDOWN(T98,3)*10000>5,ROUNDUP(T98,3)+0.001,ROUNDUP(T98,3))=0,\"\",IF((ROUNDDOWN(T98,4)*10000)-ROUNDDOWN(T98,3)*10000>5,ROUNDUP(T98,3)+0.001,ROUNDUP(T98,3)))","v":""},"","","","","","","",{"$f":"IFERROR(IF(E98>0,ROUNDDOWN(K98*B98,0)+ROUNDDOWN(ROUNDDOWN(K98*B98,0)*C98%,0)+ROUNDDOWN((ROUNDDOWN(K98*B98,0)+ROUNDDOWN(ROUNDDOWN(K98*B98,0)*C98%,0))*D98%,0)+ROUNDDOWN((M98+N98)*I98%,0)-E98-L98,\"\"),0)","v":""}]
[null,null,null,null,null,{"$f":"IF(E99>0,F98+1,\"\")","v":""},"","",null,{"$f":"IF(E99>0,J98,\"\")","v":""},"",{"$f":"IF(E99>0,IF(ROUNDDOWN(K99*B99,0)+ROUNDDOWN(ROUNDDOWN(K99*B99,0)*C99%,0)+ROUNDDOWN((ROUNDDOWN(K99*B99,0)+ROUNDDOWN(ROUNDDOWN(K99*B99,0)*C99%,0))*D99%,0)+ROUNDDOWN((M99+N99)*I99%,0)-E99>(K99*B99)*1%,0,IF(ROUNDDOWN(K99*B99,0)+ROUNDDOWN(ROUNDDOWN(K99*B99,0)*C99%,0)+ROUNDDOWN((ROUNDDOWN(K99*B99,0)+ROUNDDOWN(ROUNDDOWN(K99*B99,0)*C99%,0))*D99%,0)+ROUNDDOWN((M99+N99)*I99%,0)-E99<0,0,ROUNDDOWN(K99*B99,0)+ROUNDDOWN(ROUNDDOWN(K99*B99,0)*C99%,0)+ROUNDDOWN((ROUNDDOWN(K99*B99,0)+ROUNDDOWN(ROUNDDOWN(K99*B99,0)*C99%,0))*D99%,0)+ROUNDDOWN((M99+N99)*I99%,0)-E99)),\"\")","v":""},{"$f":"IF(E99>0,ROUNDDOWN(ROUNDDOWN(K99*B99,0)*C99%,0),\"\")","v":""},{"$f":"IF(E99>0,ROUNDDOWN((ROUNDDOWN(K99*B99,0)+ROUNDDOWN(ROUNDDOWN(K99*B99,0)*C99%,0))*D99%,0),\"\")","v":""},"","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","",{"$f":"IF(F115<>\"\",2,\"\")","v":""},{"$f":"IF(F115<>\"\",3,\"\")","v":""},{"$f":"IF(F115<>\"\",1,\"\")","v":""},{"$f":"IF(F115<>\"\",1,\"\")","v":""},""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"",{"$f":"IF(IF((ROUNDDOWN(T130,4)*10000)-ROUNDDOWN(T130,3)*10000>5,ROUNDUP(T130,3)+0.001,ROUNDUP(T130,3))=0,\"\",IF((ROUNDDOWN(T130,4)*10000)-ROUNDDOWN(T130,3)*10000>5,ROUNDUP(T130,3)+0.001,ROUNDUP(T130,3)))","v":""},"","","","","","","",{"$f":"IFERROR(IF(E130>0,ROUNDDOWN(K130*B130,0)+ROUNDDOWN(ROUNDDOWN(K130*B130,0)*C130%,0)+ROUNDDOWN((ROUNDDOWN(K130*B130,0)+ROUNDDOWN(ROUNDDOWN(K130*B130,0)*C130%,0))*D130%,0)+ROUNDDOWN((M130+N130)*I130%,0)-E130-L130,\"\"),0)","v":""}]
[null,null,null,null,null,{"$f":"IF(E131>0,F130+1,\"\")","v":""},"","",null,{"$f":"IF(E131>0,J130,\"\")","v":""},"",{"$f":"IF(E131>0,IF(ROUNDDOWN(K131*B131,0)+ROUNDDOWN(ROUNDDOWN(K131*B131,0)*C131%,0)+ROUNDDOWN((ROUNDDOWN(K131*B131,0)+ROUNDDOWN(ROUNDDOWN(K131*B131,0)*C131%,0))*D131%,0)+ROUNDDOWN((M131+N131)*I131%,0)-E131>(K131*B131)*1%,0,IF(ROUNDDOWN(K131*B131,0)+ROUNDDOWN(ROUNDDOWN(K131*B131,0)*C131%,0)+ROUNDDOWN((ROUNDDOWN(K131*B131,0)+ROUNDDOWN(ROUNDDOWN(K131*B131,0)*C131%,0))*D131%,0)+ROUNDDOWN((M131+N131)*I131%,0)-E131<0,0,ROUNDDOWN(K131*B131,0)+ROUNDDOWN(ROUNDDOWN(K131*B131,0)*C131%,0)+ROUNDDOWN((ROUNDDOWN(K131*B131,0)+ROUNDDOWN(ROUNDDOWN(K131*B131,0)*C131%,0))*D131%,0)+ROUNDDOWN((M131+N131)*I131%,0)-E131)),\"\")","v":""},{"$f":"IF(E131>0,ROUNDDOWN(ROUNDDOWN(K131*B131,0)*C131%,0),\"\")","v":""},{"$f":"IF(E131>0,ROUNDDOWN((ROUNDDOWN(K131*B131,0)+ROUNDDOWN(ROUNDDOWN(K131*B131,0)*C131%,0))*D131%,0),\"\")","v":""},"","","","",""]
[null,null,null,null,null,"",{"$f":"IF(E132>0,G131,\"\")","v":""},{"$f":"IF(E132>0,H131,\"\")","v":""},null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","",{"$f":"IF(F147<>\"\",2,\"\")","v":""},{"$f":"IF(F147<>\"\",3,\"\")","v":""},{"$f":"IF(F147<>\"\",1,\"\")","v":""},{"$f":"IF(F147<>\"\",1,\"\")","v":""},""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"",{"$f":"IF(IF((ROUNDDOWN(T162,4)*10000)-ROUNDDOWN(T162,3)*10000>5,ROUNDUP(T162,3)+0.001,ROUNDUP(T162,3))=0,\"\",IF((ROUNDDOWN(T162,4)*10000)-ROUNDDOWN(T162,3)*10000>5,ROUNDUP(T162,3)+0.001,ROUNDUP(T162,3)))","v":""},"","","","","","","",{"$f":"IFERROR(IF(E162>0,ROUNDDOWN(K162*B162,0)+ROUNDDOWN(ROUNDDOWN(K162*B162,0)*C162%,0)+ROUNDDOWN((ROUNDDOWN(K162*B162,0)+ROUNDDOWN(ROUNDDOWN(K162*B162,0)*C162%,0))*D162%,0)+ROUNDDOWN((M162+N162)*I162%,0)-E162-L162,\"\"),0)","v":""}]
[null,null,null,null,null,{"$f":"IF(E163>0,F162+1,\"\")","v":""},"","",null,{"$f":"IF(E163>0,J162,\"\")","v":""},"",{"$f":"IF(E163>0,IF(ROUNDDOWN(K163*B163,0)+ROUNDDOWN(ROUNDDOWN(K163*B163,0)*C163%,0)+ROUNDDOWN((ROUNDDOWN(K163*B163,0)+ROUNDDOWN(ROUNDDOWN(K163*B163,0)*C163%,0))*D163%,0)+ROUNDDOWN((M163+N163)*I163%,0)-E163>(K163*B163)*1%,0,IF(ROUNDDOWN(K163*B163,0)+ROUNDDOWN(ROUNDDOWN(K163*B163,0)*C163%,0)+ROUNDDOWN((ROUNDDOWN(K163*B163,0)+ROUNDDOWN(ROUNDDOWN(K163*B163,0)*C163%,0))*D163%,0)+ROUNDDOWN((M163+N163)*I163%,0)-E163<0,0,ROUNDDOWN(K163*B163,0)+ROUNDDOWN(ROUNDDOWN(K163*B163,0)*C163%,0)+ROUNDDOWN((ROUNDDOWN(K163*B163,0)+ROUNDDOWN(ROUNDDOWN(K163*B163,0)*C163%,0))*D163%,0)+ROUNDDOWN((M163+N163)*I163%,0)-E163)),\"\")","v":""},{"$f":"IF(E163>0,ROUNDDOWN(ROUNDDOWN(K163*B163,0)*C163%,0),\"\")","v":""},{"$f":"IF(E163>0,ROUNDDOWN((ROUNDDOWN(K163*B163,0)+ROUNDDOWN(ROUNDDOWN(K163*B163,0)*C163%,0))*D163%,0),\"\")","v":""},"","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","",{"$f":"IF(F179<>\"\",2,\"\")","v":""},{"$f":"IF(F179<>\"\",3,\"\")","v":""},{"$f":"IF(F179<>\"\",1,\"\")","v":""},{"$f":"IF(F179<>\"\",1,\"\")","v":""},""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"",{"$f":"IF(IF((ROUNDDOWN(T194,4)*10000)-ROUNDDOWN(T194,3)*10000>5,ROUNDUP(T194,3)+0.001,ROUNDUP(T194,3))=0,\"\",IF((ROUNDDOWN(T194,4)*10000)-ROUNDDOWN(T194,3)*10000>5,ROUNDUP(T194,3)+0.001,ROUNDUP(T194,3)))","v":""},"","","","","","","",{"$f":"IFERROR(IF(E194>0,ROUNDDOWN(K194*B194,0)+ROUNDDOWN(ROUNDDOWN(K194*B194,0)*C194%,0)+ROUNDDOWN((ROUNDDOWN(K194*B194,0)+ROUNDDOWN(ROUNDDOWN(K194*B194,0)*C194%,0))*D194%,0)+ROUNDDOWN((M194+N194)*I194%,0)-E194-L194,\"\"),0)","v":""}]
[null,null,null,null,null,{"$f":"IF(E195>0,F194+1,\"\")","v":""},"","",null,{"$f":"IF(E195>0,J194,\"\")","v":""},"",{"$f":"IF(E195>0,IF(ROUNDDOWN(K195*B195,0)+ROUNDDOWN(ROUNDDOWN(K195*B195,0)*C195%,0)+ROUNDDOWN((ROUNDDOWN(K195*B195,0)+ROUNDDOWN(ROUNDDOWN(K195*B195,0)*C195%,0))*D195%,0)+ROUNDDOWN((M195+N195)*I195%,0)-E195>(K195*B195)*1%,0,IF(ROUNDDOWN(K195*B195,0)+ROUNDDOWN(ROUNDDOWN(K195*B195,0)*C195%,0)+ROUNDDOWN((ROUNDDOWN(K195*B195,0)+ROUNDDOWN(ROUNDDOWN(K195*B195,0)*C195%,0))*D195%,0)+ROUNDDOWN((M195+N195)*I195%,0)-E195<0,0,ROUNDDOWN(K195*B195,0)+ROUNDDOWN(ROUNDDOWN(K195*B195,0)*C195%,0)+ROUNDDOWN((ROUNDDOWN(K195*B195,0)+ROUNDDOWN(ROUNDDOWN(K195*B195,0)*C195%,0))*D195%,0)+ROUNDDOWN((M195+N195)*I195%,0)-E195)),\"\")","v":""},{"$f":"IF(E195>0,ROUNDDOWN(ROUNDDOWN(K195*B195,0)*C195%,0),\"\")","v":""},{"$f":"IF(E195>0,ROUNDDOWN((ROUNDDOWN(K195*B195,0)+ROUNDDOWN(ROUNDDOWN(K195*B195,0)*C195%,0))*D195%,0),\"\")","v":""},"","","","",""]
[null,null,null,null,null,"",{"$f":"IF(E196>0,G195,\"\")","v":""},{"$f":"IF(E196>0,H195,\"\")","v":""},null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]
[null,null,null,null,null,"","","",null,"","","","","","","","","",""]

{"sheet":"طلای خام","index":1,"n_rows":200,"n_cols":34,"rows_kept":200,"cut":false,"hidden":false,"merged":[]}
["شماره فاکتور ","کد طرف حساب ","تاریخ ","نوع","الگو","موضوع","روش تسویه","کد کالا ","تعداد ","مبلغ واحد","مبلغ تخفیف",null,null,null,null,null,null,null,"عیار",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"پرداخت شده "]
[100,100,"1404-06-24",{"$f":"IF(A2<>\"\",2,\"\")","v":2},{"$f":"IF(A2<>\"\",3,\"\")","v":3},{"$f":"IF(A2<>\"\",1,\"\")","v":1},{"$f":"IF(A2<>\"\",1,\"\")","v":1},100,{"$f":"IFERROR(IF(ROUNDUP(AH2/J2,2)=0,\"\",ROUNDUP(AH2/J2,2)),\"\")","v":4.8199999999999994},66050000,{"$f":"IFERROR(IF(ROUNDDOWN(I2*J2,0)-AH2=0,\"\",ROUNDDOWN(I2*J2,0)-AH2),\"\")","v":361000},null,null,null,null,null,null,null,750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318000000]
[{"$f":"IF(AH3>0,A2+1,\"\")","v":101},{"$f":"IF(AH3>0,B2,\"\")","v":100},"1404-06-24",{"$f":"IF(A3<>\"\",2,\"\")","v":2},{"$f":"IF(A3<>\"\",3,\"\")","v":3},{"$f":"IF(A3<>\"\",1,\"\")","v":1},{"$f":"IF(A3<>\"\",1,\"\")","v":1},{"$f":"IF(AH3>0,B2,\"\")","v":100},{"$f":"IFERROR(IF(ROUNDUP(AH3/J3,2)=0,\"\",ROUNDUP(AH3/J3,2)),\"\")","v":6.02},52850000,{"$f":"IFERROR(IF(ROUNDDOWN(I3*J3,0)-AH3=0,\"\",ROUNDDOWN(I3*J3,0)-AH3),\"\")","v":157000},null,null,null,null,null,null,null,{"$f":"IF(AH3>0,S2,\"\")","v":750},null,null,null,null,null,null,null,null,null,null,null,null,null,null,318000000]
[{"$f":"IF(AH4>0,A3+1,\"\")","v":102},{"$f":"IF(AH4>0,B3,\"\")","v":100},"1404-06-24",2,3,1,1,{"$f":"IF(AH4>0,B3,\"\")","v":100},6.08,52370000,409600,null,null,null,null,null,null,null,{"$f":"IF(AH4>0,S3,\"\")","v":750},null,null,null,null,null,null,null,null,null,null,null,null,null,null,318000000]
[103,100,"1404-06-24",2,3,1,1,100,5.9399999999999995,53550000,87000,null,null,null,null,null,null,null,750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318000000]
[104,100,"1404-06-24",2,3,1,1,100,6.08,52310000,44800,null,null,null,null,null,null,null,750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318000000]
[105,100,"1404-06-24",2,3,1,1,100,6.08,52310000,44800,null,null,null,null,null,null,null,750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318000000]
[106,100,"1404-06-24",2,3,1,1,100,6.06,52530000,331800,null,null,null,null,null,null,null,750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318000000]
[107,100,"1404-06-24",2,3,1,1,100,5.67,56170000,483900,null,null,null,null,null,null,null,750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318000000]
[108,100,"1404-06-24",2,3,1,1,100,5.6899999999999995,55940000,298600,null,null,null,null,null,null,null,750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318000000]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,{"$f":"IF(A67<>\"\",2,\"\")","v":""},{"$f":"IF(A67<>\"\",3,\"\")","v":""},{"$f":"IF(A67<>\"\",1,\"\")","v":""},{"$f":"IF(A67<>\"\",1,\"\")","v":""},"",{"$f":"IFERROR(IF(ROUNDUP(AH67/J67,2)=0,\"\",ROUNDUP(AH67/J67,2)),\"\")","v":""},null,{"$f":"IFERROR(IF(ROUNDDOWN(I67*J67,0)-AH67=0,\"\",ROUNDDOWN(I67*J67,0)-AH67),\"\")","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(AH68>0,A67+1,\"\")","v":""},{"$f":"IF(AH68>0,B67,\"\")","v":""},null,"","","","",{"$f":"IF(AH68>0,B67,\"\")","v":""},"",null,"",null,null,null,null,null,null,null,{"$f":"IF(AH68>0,S67,\"\")","v":""}]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,{"$f":"IF(A131<>\"\",2,\"\")","v":""},{"$f":"IF(A131<>\"\",3,\"\")","v":""},{"$f":"IF(A131<>\"\",1,\"\")","v":""},{"$f":"IF(A131<>\"\",1,\"\")","v":""},"",{"$f":"IFERROR(IF(ROUNDUP(AH131/J131,2)=0,\"\",ROUNDUP(AH131/J131,2)),\"\")","v":""},null,{"$f":"IFERROR(IF(ROUNDDOWN(I131*J131,0)-AH131=0,\"\",ROUNDDOWN(I131*J131,0)-AH131),\"\")","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(AH132>0,A131+1,\"\")","v":""},{"$f":"IF(AH132>0,B131,\"\")","v":""},null,"","","","",{"$f":"IF(AH132>0,B131,\"\")","v":""},"",null,"",null,null,null,null,null,null,null,{"$f":"IF(AH132>0,S131,\"\")","v":""}]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,{"$f":"IF(A195<>\"\",2,\"\")","v":""},{"$f":"IF(A195<>\"\",3,\"\")","v":""},{"$f":"IF(A195<>\"\",1,\"\")","v":""},{"$f":"IF(A195<>\"\",1,\"\")","v":""},"",{"$f":"IFERROR(IF(ROUNDUP(AH195/J195,2)=0,\"\",ROUNDUP(AH195/J195,2)),\"\")","v":""},null,{"$f":"IFERROR(IF(ROUNDDOWN(I195*J195,0)-AH195=0,\"\",ROUNDDOWN(I195*J195,0)-AH195),\"\")","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(AH196>0,A195+1,\"\")","v":""},{"$f":"IF(AH196>0,B195,\"\")","v":""},null,"","","","",{"$f":"IF(AH196>0,B195,\"\")","v":""},"",null,"",null,null,null,null,null,null,null,{"$f":"IF(AH196>0,S195,\"\")","v":""}]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]
["","",null,"","","","","","",null,"",null,null,null,null,null,null,null,""]

{"sheet":"فرمت به کارفرما ","index":2,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["شماره فاکتور ","کد طرف حساب ","ردیف ","تاریخ ","نام کالا ","وزن ","مظنه- قیمت روز هر گرم","اجرت ","سود ","مبلغ دریافتی ","عیار"]
[100,{"$f":"IF(J2>0,100,\"\")","v":""},1]
[{"$f":"IF(J3>0,A2+1,\"\")","v":""},"",2]
["","",3]
["","",4]
["","",5]
["","",6]
["","",7]
["","",8]
["","",9]
["","",10]
["","",11]
["","",12]
["","",13]
["","",14]
["","",15]
["","",16]
["","",17]
["","",18]
["","",19]
["","",20]

{"sheet":"توضیحات ","index":3,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[3,1,3,17],[4,1,4,17]]}
[]
[null,"موارد زرد رنگ تکمیل شود."]
[null,"در استونها فرمول وجود دارد به هیچ عنوان دستکاری نشود پس از تکمیل اطلاعات در شیت طلا با سود و اجرت  و تکمیل موراد زرد رنگ دکمه ctrl+m را فشار دهید که به صورت اتوماتیک وزن، مبلغ تخفیف، اجرت ساخت، سود فروشنده را محاسبه خواهد نمود. "]
[null,"در این قسمتها فرمول دارد اما اگر در صورت نیاز میتوانید خودتان تغییر دهید "]
[null,"برای اکسل طلای خام از الگوی  \" نرم افزار قدیمی - طلا و جواهر\"  میتوانید استفاده کنید. اما  برای حرفه ای طلا و جواهر با سود و کارمزد باید در سمت الگو تعریف کنید "]